Assets Import

Create an asset import specification to import assets into IntelliTrack (see "Creating an Assets Import Specification").

For the Assets import specification, the AssetNumber and the ItemNumber fields are required.
External data is required to save the import specification.

External Data

An external data file is required for an import specification; see "External Data" for more information.

The external data file must contain the fields in the import specification.
In order for the data to be imported into IntelliTrack, the field order in the external data file must match the field order in the specification.

Field Selection

The following fields are available in the Assets import template.

Asset Import Fields
Field Name	Data Type	Length
AssetNumber (required)	String	200
ItemNumber (required)	String	200
Account	String	200
Active	Boolean	0
AlternateNumber	String	200
AssetComments	String	1000
AssetUDF1	String	100
AssetUDF10	String	100
AssetUDF11	String	100
AssetUDF12	String	100
AssetUDF13	String	100
AssetUDF14	String	100
AssetUDF15	String	100
AssetUDF16	String	100
AssetUDF17	String	100
AssetUDF18	String	100
AssetUDF19	String	100
AssetUDF2	String	100
AssetUDF20	String	100
AssetUDF21	Double	0
AssetUDF22	Double	0
AssetUDF23	Double	0
AssetUDF24	DateTime	0
AssetUDF3	String	100
AssetUDF4	String	100
AssetUDF5	String	100
AssetUDF6	String	100
AssetUDF7	String	100
AssetUDF8	String	100
AssetUDF9	String	100
AssetValue	Decimal	0
CalibrationPeriod	Integer	0
Category	String	200
CheckedOut	Boolean	0
CheckInTime	Time	0
CheckOutAssignee	String	200
CheckOutDateTime	DateTime	0
CheckOutDuration	Decimal	0
CheckOutDurationType	Integer	0
CheckOutSkipWeekends	Boolean	0
Condition	String	200
CurrentDepreciation	Decimal	0
DepreciationThrough	DateTime	0
Description	String	500
Division	String	200
DueBackDateTime	DateTime	0
InServiceDate	DateTime	0
ItemComments	String	1000
UDF1	String	100
UDF10	String	100
UDF11	String	100
UDF12	String	100
UDF13	String	100
UDF14	String	100
UDF15	String	100
UDF16	String	100
UDF17	String	100
UDF18	String	100
UDF19	String	100
UDF2	String	100
UDF20	String	100
UDF21	Double	0
UDF22	Double	0
UDF23	Double	0
UDF24	DateTime	0
UDF3	String	100
UDF4	String	100
UDF5	String	100
UDF6	String	100
UDF7	String	100
UDF8	String	100
UDF9	String	100
LastCalibrationDate	DateTime	0
LastMaintenanceDate	DateTime	0
Location	String	200
MaintenancePeriod	Integer	0
Manufacturer	String	200
Model	String	200
NextCalibrationDate	DateTime	0
NextMaintenanceDate	DateTime	0
OrderNumber	String	200
Owner	String	200
PictureURL	String	500
PriorDepreciation	Decimal	0
PurchaseCost	Decimal	0
PurchaseDate	Decimal	0
RentalChargeWeekends	Boolean	0
RentalCost	Decimal	0
RentalDuration	Double	0
RentalDurationType	Integer	0
RFID Tag Number	String	200
SalvageValue	Decimal	0
SerialNumber	String	50
Site	String	200
TotalDepreciation	Decimal	0
UsesExpirationDates	Boolean	0
UsesLots	Boolean	0
Uses RFID	Boolean	0
UsesSerialNumbers	Boolean	0
WarrantyExpirationDate	DateTime	0